2014-12-15 - 16215 - Enhancement - New SA115 Regional Scorecard #CrystalReportsSupport
ENHANCEMENT
16215 - New SA115 Regional Scorecard
Requirement Summary
Need to replace BU(product hierarchy level 2) field with Category(Material group 5) field in SA115 report.
Admin Info
Purpose
|
Need to replace BU(product hierarchy level 2) field with Category(Material group 5) field in SA115 report.
|
Requested By
|
Jack Mehltretter
|
Spec Created By
|
Dhananjay G
|
Spec Created Date
|
12/15/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
SA115
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
00
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
16
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Transports
|
08
|
|
TOTAL
|
40
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
01
|
Need to add Consolidated ZBPCMG5 in ZBPC_PLAN infocube & all infoproviders.
|
Greg Jackson
|
12/19/2014
|
|
02
|
Need to change 'OpenOrdersSub2' sub report material group naming formula in SA115.
|
Greg Jackson
|
12/24/2014
|
|
03
|
Need to make the changes for the regional versions of the SA115 report.
|
Mark Grzechowiak
|
12/30/2014
|
|
Functional Requirement
Purpose/WHY:
12-15-2014 - Email from Mark Harris:
As I discussed with you on IM I Have created a ticket 16215 in ReCAP for you to alter the SA115 report. We need to replace BU (product hierarchy level 2) field with Category(Material group 5) field. Please let me know when this can be done. Do not alter the SA110 report.
In Scope:
Modify BEx queries to add Category(Material group 5) info object to related info providers.
Out of Scope:
Since the same BEx queries are used by SA110 donot remove the SBU(product hierarchy level 2) in those queries.
Solution Summary
1. Need to create a new infoo bject for Material Group5 consolidation.
2. Need to add the logic for Material Group5 consolidation in Material Sales Info object.
3. Need to change the logic for Consolidated SBU in BPC Planning infocube to populate data for SBU only if Fiscal year is <= 2014.
3. Need to add consolidated Material group 5 in BPC Planning infocube & write logic to populate consolidated Material Group5 if Fiscal Year is >= 2015.
4. Need to add consolidated Material group 5 in Brazil & Japan Open Orders, Brazil & Japan Sales infocubes & make necessary changes to populate Material Group5 consolidation in these Info providers.
5. Need to switch on 0MAT_SALES_ ZBPCMG5 as navigational attribute in Open Orders, Contract, Condition, COPA infocubes.
6. Need to add consolidated Material Group5 in ZMP_SCARD Multiprovider & make necessary assignments from corresponding infoproviders(Except Retail Source).
7. Need to add the Category(ZBPCMG5) info object in the BEx queries & Regional Queries of SA115 report in BPD(BW 7.3 Development).
8. Need to create an open transport request & collect all the required changes into this transport request.
9. Need to check if all the BEx queries meet the NEC Standards.
10. Need to replace BU(product hierarchy level 2) field with Category(Material group 5) field in SA115 report only.
11. Need to make the changes for the regional versions of SA115 report also.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Need to check if the data is populating in 0MAT_SALES as per the new logic.
|
Data should be populated as per the logic written.
|
2
|
Need to check if ZBPCMG5 is populating only if fiscal year >=2015.
|
Data should be populated for values >= 2015.
|
3
|
Need to check if assignments are correctly done in Scorecard multiprovider.
|
Assignments should be done correctly from respective infoproviders.
|
4
|
Need to check if all the changes & objects are collected ino the transport request.
|
All the changes & Objects should be colllected successfully into the transport request.
|
3
|
Report Format.
|
Should be as per NEC crystal standard checklist.
|
4
|
Execute Crystal Report in Crystal Designer tool after changes.
|
Report should execute successfully in Crystal Designer tool.
|
5
|
Schedule the Report in NEC BI Launch Pad.
|
Report should execute successfully in NEC BI Launch Pad.
|
Solution Details
1. Need to create a new infoobject for Material Group5 consolidation(ZBPCMG5).
2. Need to add the logic for Material Group5 consolidation(ZBPCMG5) in Material Sales(0MAT_SALES) infoprovider.
3. Need to change the logic for Consolidated SBU(ZBPCSBU) in BPC Planning infocube(ZBPC_PLAN) to populate data only if Fiscal year is <= 2014.
4. Need to add consolidated Material Group5(ZBPCMG5) in BPC Planning infocube(ZBPC_PLAN) & write logic to populate consolidated Material Group 5(ZBPCMG5) if Fiscal Year is >= 2015.
5. Need to add consolidated Material Group5(ZBPCMG5) in Brazil & Japan Open Orders(ZBJ_OPEN), Brazil & Japan Sales(ZBJ_SALES) infocubes & make necessary changes to populate Material Group5 consolidation (ZBPCMG5) in these providers.
6. Need to switch on 0MAT_SALES_ ZBPCMG5 as navigational attribute in Open Orders Cube(ZSDC_OPN), Contract Cube(ZSD_CONTR), Condition Cube(ZSD_C15) & COPA infocubes(ZCOPA_C03).
7. Need to add Consolidated Material Group5 (ZBPCMG5) infoobject in ZMP_SCARD Multiprovider & make necessary assignments from corresponding infoproviders(Except Retail Source).
8. Need to add the Category(ZBPCMG5) infoobject in the BEx queries & Regional Queries of SA115 report in BPD(BW 7.3 Development).
9. Need to create an open transport request & collect all the required changes into this transport request.
10. Need to check if all the BEx queries meet the NEC Standards.
11. Need to replace BU(product hierarchy level 2) field with Category(Material group 5) field in SA115 report only.
12. Need to update sources in the SA115 report after adding the Category(Material group 5) infoobject.
13. Need to make the changes for the regional versions of the SA115 report also.
14. Need to check & follow NEC standards while modifying the reports.
Issues
None
OpenOrdersSub2